Creating and Selecting a Database
If the administrator creates your database for you when setting up your permissions, you can begin using it. Otherwise,
you need to create it yourself:

mysql> CREATE DATABASE menagerie;
Under Unix, database names are case-sensitive (unlike SQL keywords), so you must always refer to your database as
menagerie, not as Menagerie, MENAGERIE, or some other variant. This is also true for table names. (Under Windows, this
restriction does not apply, although you must refer to databases and tables using the same lettercase throughout a given
query. However, for a variety of reasons, the recommended best practice is always to use the same lettercase that was
used when the database was created.)

Note
If you get an error such as ERROR 1044 (42000): Access denied for user 'micah'@'localhost' to database 'menagerie' when
attempting to create a database, this means that your user account does not have the necessary privileges to do so.
Discuss this with the administrator or see Section 6.2, “Access Control and Account Management”.

Creating a database does not select it for use; you must do that explicitly. To make menagerie the current database, use
this statement:

mysql> USE menagerie